Enter text, numbers, dates, and times in a spreadsheet

1. Click the cell where you want to enter data.
2. Type the data, and then press ENTER or the TAB key.

Notes

• To separate the parts of a date, use a slash or a hyphen; for example, type 9/5/2002 or 5-Sep-2002.

• To enter a time based on the 12-hour clock, type a space and then type AM or PM after the time; for example, type 9:00 PM. Otherwise, the spreadsheet enters the time as AM.

• Precede formulas with an equal (=) sign.

• To enter a hyperlink, type the URL address, beginning with a protocol such as http:// or ftp://, and then press ENTER.

• To enter the same data in several cells, select the cells, type the data, and then press CTRL+ENTER.